BEGIN Transaction

INSERT INTO MembershipType(MembershipTypeId, PackageName, Description, ContractType, DurationType, DurationQuantity, OffPeakMembership, CancelAnyTime) VALUES ('P4', 'Daily-Classes', 'Seperate cLasses for members/non-Members.', 'single class session', 'Classes', '1', '07.99', '1')

---Firstly i will be adding a new fixed term memebership, this will be added to my MembershipTypeId.
--this will be to specify how the 'classes' can be used.

 VALUES ('ContinousPay', 'OneTimePay', 'SingleUse', 'TimeOfDay');

 UPDATE MembershipType
 SET MembershipTypeId = 'Classes';
 WHERE Customer = 'BB4788';

 UPDATE Customer
 SET SortCode = '23-43-51';
 WHERE Customer ='BB4788';

 COMMIT TRANSACTION
 Transaction;